1. To-Increase Dynamics 365 for Finance & Operations
  2. Data modeling studio
  3. Setting up and maintaining Data modeling studio
  4. Set up and maintain data models

Deploy data model

If a data model is set up, and applicable transformations are defined, deploy the data model. You deploy a data model to prepare the target database for data exports.

When deployed, you can validate the target database.


DMS Administrator DMS Administrator Start Start Apply transformations  on deploy of the  data model? Apply transformations  on deploy of the  data model? Select deploy transformations Select deploy transformations For each data model you can define transformations to be executed automatically after the data model is deployed. You can define transformations of these categories: Modeling: You can use modeling transformations to create views in the target database. These views are created based on the business entities that are created in the target database on deploy. Instrumentation: You can use instrumentation transformations to create objects, stored procedures, and schemas in the target database. You can also use these transformations to do calculations on the metadata that is exported on deploy. A transformation contains one or several SQL statements which define the transformation actions to be done. Procedure 1. Go to Data modeling studio > Data modeling studio > Data models. 2. In the list, find and select the desired data model. 3. Click Transform. 4. Sub-task: Add several transformations at once. 5. Click Add multiple.... 6. In the list, find and select the desired transformations. Note: Only the transformations of category 'Modeling' and 'Instrumentation' are shown in the list. 7. Click Ok. 8. Sub-task: Add one transformation. 9. Click Add. 10. In the Template field, enter or select a value. Note: Only the transformations of category 'Modeling' and 'Instrumentation' are shown in the lookup. 11. Sub-task: Define transformation sequence. 12. Define the sequence in which the transformations are applied. To move a transformation one position up, click Up. Note: You can also manually set the sequence in the Order field. 13. To move a transformation one position down, click Down. Note: You can also manually set the sequence in the Order field. 14. Click OK. 15. Close the page. Notes If the data model is already deployed, you can apply some transformations without re-deploying the data model. To do so, on the Select transformations dialog, to apply: A selection of transformations, select the transformations, and click Apply selected. All defined transformations, click Apply all. Deploy data model Deploy data model If a data model is set up, and applicable transformations are defined, deploy the data model. You deploy a data model to prepare the target database for data exports. Procedure 1. Go to Data modeling studio > Data modeling studio > Data models. 2. In the list, find and select the desired data model. 3. Click Deploy. Notes Usually, you deploy a data model once. However, if changes are made to the data model, you can re-deploy it. On re-deploy, tables that are created during a previous deploy, are deleted from the target database and recreated. This to ensure an up-to-date schema. As a consequence, already exported data is deleted as well. The next time you export the data model, the data is recreated in the target database. If only one of the data sets, as defined for the data model, is changed, you can also deploy only this data set from the Data sets page. Validate data model Validate data model If you have deployed a data model, you can run the validation. The validation is done on the target database. Validation checks if, in the target database, the: Schema exists that is defined for the data model. Target database exists. Change tracking is enabled. Procedure 1. Go to Data modeling studio > Data modeling studio > Data models. 2. In the list, find and select the desired data model with state 'Deployed'. 3. Click Validate. End End Yes No

Activities

Name Responsible Description

Select deploy transformations

DMS Administrator

For each data model you can define transformations to be executed automatically after the data model is deployed.

You can define transformations of these categories:

  • Modeling: You can use modeling transformations to create views in the target database. These views are created based on the business entities that are created in the target database on deploy.
  • Instrumentation: You can use instrumentation transformations to create objects, stored procedures, and schemas in the target database. You can also use these transformations to do calculations on the metadata that is exported on deploy.

A transformation contains one or several SQL statements which define the transformation actions to be done.

Deploy data model

DMS Administrator

If a data model is set up, and applicable transformations are defined, deploy the data model. You deploy a data model to prepare the target database for data exports.

Validate data model

DMS Administrator

If you have deployed a data model, you can run the validation.

The validation is done on the target database. Validation checks if, in the target database, the:

  • Schema exists that is defined for the data model.
  • Target database exists.
  • Change tracking is enabled.

See also

Provide feedback